{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Polecenia","zadanie 1","zadanie 2","zadanie 3","zadanie 4","zadanie 5"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Polecenia","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
["Nr grupy","Nazwisko","Imię","Nr albumu","Data","Nr zadania","Termin","Czas przygotowań [h]"]
[1,null,null,null,"2019-07-02",4,"pierwszy"]
[]
[null,{"$f":"IF(OR(A2=\"\",B2=\"\",C2=\"\",D2=\"\"),\"UZUPEŁNIJ SWOJE DANE!\",\"\")","v":"UZUPEŁNIJ SWOJE DANE!"}]
[]
[null,"Zasady kolokwium:"]
[null,"1. Zadania rozwiązywane SAMODZIELNIE - zabroniony jest kontakt z osobami w laboratorium jak i poza nim."]
[null,"2. Dozwolone materiały pomocnicze: notatki, książki."]
[null,"3. Wyniki należy umieszczać w żółtych polach obok wyszczególnionych statystyk!"]
[null,"4. Nie wolno zaokrąglać wyników!"]
[null,"5. Nie wolno zmieniać nazw istniejących arkuszy ani nazwy pliku."]
[null,"6. Plik należy przesłać do godziny 10:00 na adres Jacek.Szandula@ue.wroc.pl. W tytule maila podać (numer grupy) (przecinek) (spacja) (nazwisko) np.: 12, Kowalski"]
[]
[null,"Po kolokwium:"]
[null,"1. Ze strony szandulajacek.republika.pl należy pobrać plik z rozwiązanymi zadaniami."]
[null,"2. Aby sprawdzić poprawność rozwiązanych zadań należy:"]
[null,null,"a) otworzyć swój plik, przejść do arkusza zadanie 1, skopiować obszar odpowiedzi (czarna ramka), "]
[null,null,"b) otworzyć plik z rozwiązaniami, przejść do arkusza zadanie 1, zaznaczyć obszar odpowiedzi (czarna ramka),"]
[null,null,"c) wybrać polecenie WKLEJ SPECJALNIE, zaznaczyć opcję WARTOŚCI I FORMATY LICZB,"]
[null,null,"d) powtórzyć kroki a - c dla pozostałych zadań."]
[null,"3. Uzyskany wynik można odczytać w arkuszu Polecenia pliku z rozwiązaniami zadań."]
[]
[]
[]
[{"$f":"ADDRESS(ROW('zadanie 1'!H2),COLUMN('zadanie 1'!H2),4,1)","v":"H2"},{"$f":"ADDRESS(ROW('zadanie 1'!M13),COLUMN('zadanie 1'!M13),4,1)","v":"M13"}]
[{"$f":"ADDRESS(ROW('zadanie 2'!I2),COLUMN('zadanie 2'!I2),4,1)","v":"I2"},{"$f":"ADDRESS(ROW('zadanie 2'!N12),COLUMN('zadanie 2'!N12),4,1)","v":"N12"}]
[{"$f":"ADDRESS(ROW('zadanie 3'!H3),COLUMN('zadanie 3'!H3),4,1)","v":"H3"},{"$f":"ADDRESS(ROW('zadanie 3'!L14),COLUMN('zadanie 3'!L14),4,1)","v":"L14"}]
[{"$f":"ADDRESS(ROW('zadanie 4'!I2),COLUMN('zadanie 4'!I2),4,1)","v":"I2"},{"$f":"ADDRESS(ROW('zadanie 4'!M17),COLUMN('zadanie 4'!M17),4,1)","v":"M17"}]
[{"$f":"ADDRESS(ROW('zadanie 5'!I4),COLUMN('zadanie 5'!I4),4,1)","v":"I4"},{"$f":"ADDRESS(ROW('zadanie 5'!Q17),COLUMN('zadanie 5'!Q17),4,1)","v":"Q17"}]

{"sheet":"zadanie 1","index":1,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[10,8,10,10],[11,8,11,10],[12,8,12,10],[2,8,2,10],[3,8,3,10],[4,8,4,10],[7,8,7,10],[8,8,8,10],[9,8,9,10]]}
["Nr okresu","Sprzedaż w zł",null,"Na podstawie tygodniowych wartości sprzedaży określ składowe szeregu czasowego"]
[1,112793.37,null,null,null,null,null,"a) Przeprowadź test współczynnika korelacji; α = 0,1"]
[2,143149.56,null,null,null,null,null,null,"Współczynnik korelacji = "]
[3,149192.22,null,null,null,null,null,null,"Statystyka testowa = "]
[4,170527.67,null,null,null,null,null,null,"Wartość krytyczna  ="]
[5,173526.34]
[6,186655.23,null,null,null,null,null,"b) Składowe szeregu czasowego"]
[7,191514.68,null,null,null,null,null,null,"Wahania przypadkowe"]
[8,216364.51,null,null,null,null,null,null,"Stały poziom"]
[9,204724.45,null,null,null,null,null,null,"Trend malejący"]
[10,224262.33,null,null,null,null,null,null,"Trend rosnący"]
[11,220715.03,null,null,null,null,null,null,"Wahania sezonowe"]
[12,223047.61,null,null,null,null,null,null,"Wahania cykliczne"]
[13,228523.89]
[14,246292.09]
[15,229523.26]
[16,235495.86]
[17,236540.95]
[18,247972.63]
[19,245443.38]
[20,259131.2]
[21,250621.5]
[22,250860.81]
[23,253950.35]
[24,260525.06]
[25,238842]
[26,267878.56]
[27,269948.78999999998]
[28,266389.78000000003]
[29,265414.76]
[30,247624.69]
[31,250203.81]
[32,282232.21000000002]
[33,262498.58]
[34,270228.01]
[35,259731.97]
[36,278427.90000000002]
[37,272050.71999999997]
[38,278462.44]
[39,283070.56]
[40,274776.19]
[41,281088.12]
[42,272950.56]
[43,289317.26]
[44,278211.27]
[45,284574.65999999997]
[46,269106.90999999997]
[47,282391.46999999997]
[48,294569.46999999997]
[49,297887.09999999998]
[50,284799.03000000003]
[51,292114.05]
[52,291923.20000000001]
[53,278791.90000000002]
[54,300850.82]
[55,286617.90000000002]
[56,293992.78999999998]
[57,292638.49]
[58,296252.94]
[59,286493.51]

{"sheet":"zadanie 2","index":2,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,12,8,13],[2,9,2,11],[3,9,3,11],[5,9,5,11],[6,9,6,11],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11]]}
["Nr okresu","Sprzedaż w zł",null,"Na podstawie tygodniowych wartości sprzedaży w zł wyznacz:"]
[1,13502.04,null,null,null,null,null,null,"a) parametry modelu"]
[2,13402.58,null,null,null,null,null,null,null,"Wyraz wolny ="]
[3,15566.13,null,null,null,null,null,null,null,"Współczynnik kierunkowy ="]
[4,15516.2,null,null,null,null,null,null,"b) Miary dopasowania modelu"]
[5,17379.46,null,null,null,null,null,null,null,"Współczynnik determinacji ="]
[6,17938.189999999999,null,null,null,null,null,null,null,"Standardowy błąd oceny  modelu ="]
[7,18565.599999999999,null,null,null,null,null,null,"c) Uzupełnij poniższą tabelę"]
[8,19808.900000000001,null,null,null,null,null,null,"Nr okresu","Prognoza punktowa","Bezwzględny błąd prognozy ex ante","Względny błąd prognozy ex ante","Prognoza przedziałowa (p = 0,9)"]
[9,20231.66,null,null,null,null,null,null,null,null,null,null,"od","do"]
[10,20685.599999999999,null,null,null,null,null,null,36]
[11,20550.96,null,null,null,null,null,null,37]
[12,20429.45]
[13,23712.3]
[14,24054.080000000002]
[15,24558.48]
[16,25621.86]
[17,25365.21]
[18,29621.38]
[19,27355.27]
[20,28117.08]
[21,29512.52]
[22,31542.52]
[23,31665.96]
[24,32311.119999999999]
[25,32670.73]
[26,32917.379999999997]
[27,34498.660000000003]
[28,35888.449999999997]
[29,36104.230000000003]
[30,37115.1]
[31,37181.65]
[32,37698.31]
[33,38474.339999999997]
[34,41559.120000000003]
[35,41527.47]

{"sheet":"zadanie 3","index":3,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,8,3,10],[4,8,4,10],[5,8,5,10],[6,8,6,10],[7,8,7,10],[10,8,11,8],[10,9,11,9],[10,10,11,10]]}
["Nr okresu","Sprzedaż w tys. zł",null,null,null,null,null,"Przy pomocy Solvera dokonaj optymalizacji modelu Holta przyjmując: F1 = y1, S1 = y2 – y1. "]
[1,145.30000000000001,null,null,null,null,null,"Optymalizację przeprowadź dla punktów startowych α = 0,5, β = 0,5."]
[2,144.19999999999999,null,null,null,null,null,"a) Wyznacz"]
[3,145.1,null,null,null,null,null,null,"α =",null,null,0.5]
[4,143.4,null,null,null,null,null,null,"β =",null,null,0.5]
[5,140.19999999999999,null,null,null,null,null,null,"s* ="]
[6,139.80000000000001,null,null,null,null,null,null,"Fn ="]
[7,139.6,null,null,null,null,null,null,"Sn ="]
[8,138.1]
[9,136.80000000000001,null,null,null,null,null,"b) Uzupełnij poniższą tabelę"]
[10,135,null,null,null,null,null,null,"Nr okresu","Prognoza punktowa","Względny błąd prognozy"]
[11,134.6]
[12,134.6,null,null,null,null,null,null,37]
[13,133.30000000000001,null,null,null,null,null,null,38]
[14,132.19999999999999]
[15,132.4]
[16,130.30000000000001]
[17,129.69999999999999]
[18,128.4]
[19,126.9]
[20,126]
[21,124.3]
[22,122.7]
[23,120.5]
[24,119.7]
[25,116.9]
[26,115.3]
[27,113.6]
[28,113.2]
[29,110.9]
[30,108.6]
[31,106.1]
[32,105.5]
[33,101.7]
[34,100.3]
[35,97.7]
[36,96.7]

{"sheet":"zadanie 4","index":4,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[12,12,13,12],[2,9,2,11],[3,9,3,11],[4,9,4,11],[10,9,10,11],[12,10,13,10],[12,11,13,11]]}
["Nr okresu","Sprzedaż w zł",null,"Na podstawie danych kwartalnych o wartości sprzedaży w zł wyznacz:"]
[1,3852.65,null,null,null,null,null,null,"a) parametry modelu"]
[2,5483.95,null,null,null,null,null,null,null,"Wyraz wolny ="]
[3,5968.09,null,null,null,null,null,null,null,"Współczynnik kierunkowy ="]
[4,8714.17,null,null,null,null,null,null,null,"wskaźniki sezonowości"]
[5,4760.1499999999996,null,null,null,null,null,null,null,null,null,"c1 ="]
[6,5860.23,null,null,null,null,null,null,null,null,null,"c2 ="]
[7,6344.21,null,null,null,null,null,null,null,null,null,"c3 ="]
[8,10105.18,null,null,null,null,null,null,null,null,null,"c4 ="]
[9,5420.34,null,null,null,null,null,null,"b) Miary dopasowania modelu"]
[10,6300.89,null,null,null,null,null,null,null,"Względny poziom reszt ="]
[11,7932.72,null,null,null,null,null,null,"c) Prognozy na podane okresy"]
[12,11027.24,null,null,null,null,null,null,null,null,"Nr okresu","Prognoza wstępna","Prognoza ostateczna"]
[13,5607.72]
[14,7814.24,null,null,null,null,null,null,null,null,29]
[15,8241.6200000000008,null,null,null,null,null,null,null,null,30]
[16,11704.48,null,null,null,null,null,null,null,null,31]
[17,6151.32]
[18,8168.49]
[19,9242.8700000000008]
[20,12096.51]
[21,7194.33]
[22,8720.08]
[23,8937.77]
[24,13408.69]
[25,7290.3]
[26,10019.65]
[27,9543.4500000000007]
[28,14549.8]

{"sheet":"zadanie 5","index":5,"n_rows":41,"n_cols":17,"rows_kept":41,"cut":false,"hidden":false,"merged":[[14,14,15,14],[14,15,14,16],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[4,9,4,11],[5,9,5,11],[6,9,6,11],[7,9,7,11],[10,9,10,11],[11,9,11,11]]}
["Nr okresu","Y","X1","X2","X3",null,null,null,"Na podstawie wartości zmiennych Y, X1, X2 i X3 zbuduj model ekonometryczny wyjaśniający zmienną Y"]
[1,57.1,0.3896,54.77,2582,null,null,null,"Poziom istotności dla oceny parametrów modelu przyjmij α = 0,05"]
[2,51,0.3276,43.81,2418,null,null,null,"Wyznacz"]
[3,84.4,0.43969999999999998,44.52,3640,null,null,null,"a) parametry modelu"]
[4,49.5,0.29199999999999998,49.5,2467,null,null,null,null," α0 ="]
[5,48.2,0.35120000000000001,47.16,2469,null,null,null,null," α1 ="]
[6,53.9,0.36609999999999998,53.58,2719,null,null,null,null," α2 ="]
[7,59.7,0.39079999999999998,47.58,2974,null,null,null,null," α3 ="]
[8,75.3,0.3916,46.66,3568]
[9,81.900000000000006,0.40970000000000001,45.68,3850,null,null,null,"b) Miary dopasowania modelu"]
[10,73.7,0.4385,46.88,3614,null,null,null,null,"Współczynnik determinacji ="]
[11,63.5,0.39140000000000003,51.86,3304,null,null,null,null,"Standardowy błąd oceny  modelu ="]
[12,52.1,0.33789999999999998,47.08,2957]
[13,71.3,0.3846,39.270000000000003,3680,null,null,null,"c) Uzupełnij poniższą tabelę."]
[14,69.599999999999994,0.3856,42.03,3668,null,null,null,"Nr okresu","Prognoza punktowa X1","Prognoza punktowa X2","Prognoza punktowa X3","Prognoza punktowa Y","Bezwzględny błąd prognozy ex ante dla Y","Względny błąd prognozy ex ante dla Y","Prognoza przedziałowa dla Y (p = 0,9)"]
[15,60.7,0.32900000000000001,49.75,3407,null,null,null,null,null,null,null,null,null,null,"od","do"]
[16,63.1,0.29099999999999998,48.77,3541,null,null,null,41,0.26124115384615387,30.530576923076914,4992.2384615384617]
[17,43.3,0.24529999999999999,44.71,2898]
[18,84,0.4123,38.119999999999997,4372]
[19,57.1,0.3105,49.13,3480]
[20,41.1,0.251,45.38,2970]
[21,62.6,0.3125,31.54,3771]
[22,78.099999999999994,0.36880000000000002,36.06,4365]
[23,74.900000000000006,0.34539999999999998,35.43,4302]
[24,76,0.34920000000000001,35.54,4390]
[25,60.2,0.27589999999999998,45.24,3889]
[26,50.8,0.2591,43.01,3609]
[27,39.1,0.21729999999999999,38.020000000000003,3247]
[28,78.3,0.33829999999999999,30.87,4672]
[29,66.099999999999994,0.30969999999999998,28.4,4294]
[30,60.9,0.30709999999999998,37.94,4162]
[31,68.5,0.31459999999999999,38.520000000000003,4476]
[32,49.8,0.22109999999999999,38.26,3871]
[33,78.099999999999994,0.33339999999999997,42.2,4915]
[34,90.5,0.3604,29.76,5397]
[35,87.6,0.34250000000000003,32.81,5347]
[36,66.099999999999994,0.27179999999999999,34.61,4644]
[37,67.2,0.2908,34.869999999999997,4730]
[38,76.599999999999994,0.31790000000000002,22.67,5110]
[39,57.5,0.21260000000000001,33.07,4493]
[40,58.3,0.1867,33.04,4571]